package com.bw.gmallapi.mapper;

import com.bw.gmallapi.entity.KeyWordBean;
import com.bw.gmallapi.entity.ProvinceBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface KeyWordMapper {

    @Select("select keyword,sum(ct) word_count  from kw_2203A where toYYYYMMDD(stt)=#{date} group by keyword ")
    List<KeyWordBean> selectKeyWord(Integer date);
}
